PriceLineRewardDerivationRuleEligibility

Entity Definition

Logical Name : PriceLineRewardDerivationRuleEligibility
Physical Name : CO_EL_PRC_LN_PRDV

Defines an association between a MERCHANDISE STRUCTURE RewardDerivationRule and a PRICE LINE for the purposes of triggering a reward. Example: For any item in Department 232 priced 99.99 to 129.99 take 10% off (covers only those items so this is a line item group subtotal reward derivation rule).

Data Definition

Attribute	Description	Physical Name	Domain	Data Type	Foreign Key Table
RewardDerivationRuleEligibilityID (FK)(PK)	A unique identifier for a Price Derivation Rule Eligibility.	ID_EL_PRDV	Identity	integer
MerchandiseHierarchyGroupID (FK)	Unique system assigned identifier for a group or class of merchandise.	ID_MRHRC_GP	Identity	integer	PriceLine(AS_LN_PRC)
PriceLineID (FK)	A unique identifier for this price point.	ID_LN_PRC	Identity	integer	PriceLine(AS_LN_PRC)

Relationships

Parent Entity	Verb Phrase	Child Entity
PriceLine	is eligible for	PriceLineRewardDerivationRuleEligibility
RewardEligibilityRule	can be a	PriceLineRewardDerivationRuleEligibility

Logical Views containing PriceLineRewardDerivationRuleEligibility

Logical View
Logical 01400 - Item Rewards Derivation - Transaction Level